home *** CD-ROM | disk | FTP | other *** search
/ Kompuutteri Kaikille K-CD 2002 #1 / K-CD_2002-01.iso / Delphi / INSTALL / program files / Borland / Delphi6 / Ocx / Vci / Form1 / VCF1.CNT (.txt) < prev    next >
Microsoft Windows Help File Content  |  1995-10-27  |  24KB  |  683 lines

  1. :Base vcf1.hlp
  2. :Title Formula One 3.0 Help
  3. 1 Introduction to Formula One
  4. 2 Welcome to Formula One=IDH_Contents
  5. 2 Reaching Our Technical Support Department=Reaching_Our_Technical_Support_Department
  6. 2 New Features in the Professional Edition of Formula One 3.0=New_Features_in_Version_3_0
  7. 1 Getting Started
  8. 2 Adding the OCX to Your Application=Adding_the_OCX_to_Your_Application
  9. 2 Distributing Formula One Applications=Distributing_Formula_One_Applications
  10. 1 Views and Workbooks
  11. 2 Using Views and Workbooks=Using_Views_and_Workbooks
  12. 2 Working with Workbooks=Working_with_Workbooks
  13. 2 Working with Views=Working_with_Views
  14. 2 Using View Information=Using_View_Information
  15. 2 Attaching Views to Workbooks=Attaching_Views_to_Workbooks
  16. 2 One View That Can Display Multiple WorkBooks=One_View_That_Can_Display_Multiple_WorkBooks
  17. 2 One Workbook Displayed in Multiple Views=One_Workbook_Displayed_in_Multiple_Views
  18. 2 Controlling What is Displayed in a View=Controlling_What_is_Displayed_in_a_View
  19. 1 Workbooks and Worksheets
  20. 2 The Formula One Workbook=The_Formula_One_Workbook
  21. 2 Worksheet Management
  22. 3 Inserting Worksheets=Inserting_Worksheets
  23. 3 Sheet Index List=Sheet_Index_List
  24. 3 Selecting Worksheets=Selecting_Worksheets
  25. 3 Working with a Group of Worksheets=Working_with_a_Group_of_Worksheets
  26. 3 Inserting Multiple Worksheets=Inserting_Multiple_Worksheets
  27. 3 Deleting Worksheets=Deleting_Worksheets
  28. 3 Renaming Worksheets=Renaming_Worksheets
  29. 3 Positioning Worksheet Tabs=Positioning_Worksheet_Tabs
  30. 2 Worksheet Navigation
  31. 3 Navigating Through Worksheets=Navigating_Through_Worksheets
  32. 3 Using Keyboard Commands=Using_Keyboard_Commands
  33. 3 Performing Mouse Actions=Performing_Mouse_Actions
  34. 2 Selecting Parts of Worksheets
  35. 3 Selecting Cells=Selecting_Cells
  36. 3 Selecting Cells with the Mouse=Selecting_Cells_with_the_Mouse
  37. 3 Selecting Cells with Properties and Methods=Selecting_Cells_with_Properties_and_Methods
  38. 3 Selecting Rows and Columns=Selecting_Rows_and_Columns
  39. 1 Workbook Designer
  40. 2 Using the Workbook Designer=Using_the_Workbook_Designer
  41. 2 Workbook Designer Overview=Workbook_Designer_Overview
  42. 2 Workbook Designer Menus
  43. 3 File Menu=File_Menu
  44. 3 Edit Menu=Edit_Menu
  45. 3 View Menu=View_Menu
  46. 3 Data Menu=Data_Menu
  47. 3 Sheet Menu=Sheet_Menu
  48. 3 Format Menu=Format_Menu
  49. 3 Object Menu=Object_Menu
  50. 1 Working with Worksheets
  51. 2 Entering Data in Worksheets
  52. 3 Worksheet Data Entry=Worksheet_Data_Entry
  53. 3 Adding the edit bar=Adding_the_edit_bar
  54. 3 Data Entry
  55. 4 Entering Data with Properties=Entering_Data_with_Properties
  56. 4 Entering Multi-Line Data=Entering_Multi_Line_Data
  57. 4 Limiting Data Entry=Limiting_Data_Entry
  58. 4 Limiting Formula Entry=Limiting_Formula_Entry
  59. 4 Locking Cells=Locking_Cells
  60. 4 Displaying Formulas=Displaying_Formulas
  61. 4 Worksheet Errors=Worksheet_Errors
  62. 4 AutoFill Lists
  63. 5 Using AutoFill Lists=Using_AutoFill_Lists
  64. 5 Adding AutoFill Lists=Adding_AutoFill_Lists
  65. 5 Deleting AutoFill Lists=Deleting_AutoFill_Lists
  66. 4 Data Validation
  67. 5 Validating Data=Validating_Data
  68. 5 The Validation Formula=The_Validation_Formula
  69. 4 Types of Worksheet Data
  70. 5 Worksheet Data Types=Worksheet_Data_Types
  71. 5 Entering Constant Values=Entering_Constant_Values
  72. 5 Entering Formulas=Entering_Formulas
  73. 5 Formula Operators=Formula_Operators
  74. 5 Operator Precedence=Operator_Precedence
  75. 4 Referencing Cells
  76. 5 Cell References=Cell_References
  77. 5 Absolute and Relative References=Absolute_and_Relative_References
  78. 5 References to Other Worksheets=References_to_Other_Worksheets
  79. 5 References to Multiple Worksheets=References_to_Multiple_Worksheets
  80. 5 External References=External_References
  81. 5 Automatically Entering Cell References=Automatically_Entering_Cell_References
  82. 5 Using Names=Using_Names
  83. 4 Worksheet Functions
  84. 5 Built-In Worksheet Functions=Built_In_Worksheet_Functions
  85. 5 Understanding Functions=Understanding_Functions
  86. 5 Entering Functions=Entering_Functions
  87. 5 Nesting Functions=Nesting_Functions
  88. 5 Entering Arguments=Entering_Arguments
  89. 5 Syntax Errors=Syntax_Errors
  90. 3 Worksheet Calculation
  91. 4 Calculating Worksheets=Calculating_Worksheets
  92. 4 Setting Automatic Recalculation=Setting_Automatic_Recalculation
  93. 4 Solving Circular References=Solving_Circular_References
  94. 2 Editing Worksheets
  95. 3 Cut, Copy, and Paste Methods=Cut_Copy_and_Paste_Methods
  96. 3 Copying Data Across Ranges=Copying_Data_Across_Ranges
  97. 3 Copying Data Interactively=Copying_Data_Interactively
  98. 3 Interactively Copying Ranges=Interactively_Copying_Ranges
  99. 3 Moving Data=Moving_Data
  100. 3 Interactively Moving Ranges=Interactively_Moving_Ranges
  101. 3 Inserting Cells, Rows, and Columns=Inserting_Cells_Rows_and_Columns
  102. 3 Clearing and Deleting Cells, Rows, and Columns=Clearing_and_Deleting_Cells_Rows_and_Columns
  103. 3 Sorting Data in Worksheets=Sorting_Data_in_Worksheets
  104. 2 Formatting Worksheets
  105. 3 Formatting Worksheets=Formatting_Worksheets
  106. 3 Formatting Data
  107. 4 Built-in Number Formats=Built_in_Number_Formats
  108. 4 Formatting Rows and Columns=Formatting_Rows_and_Columns
  109. 4 Obtaining Formatted Text=Obtaining_Formatted_Text
  110. 4 Custom Formatting=Custom_Formatting
  111. 4 Aligning Data=Aligning_Data
  112. 3 Formatting Rows and Columns
  113. 4 Changing Row Heights and Column Widths=Changing_Row_Heights_and_Column_Widths
  114. 4 Interactively Sizing Rows and Columns=Interactively_Sizing_Rows_and_Columns
  115. 4 Sizing Rows and Columns with Properties and Methods=Sizing_Rows_and_Columns_with_Properties_and_Methods
  116. 4 Fixing Rows and Columns=Fixing_Rows_and_Columns
  117. 4 Setting Cell Borders and Colors=Setting_Cell_Borders_and_Colors
  118. 3 Formatting Row and Column Headings
  119. 4 Formatting Row and Column Headings=Formatting_Row_and_Column_Headings
  120. 4 Selecting Row and Column Heading Areas=Selecting_Row_and_Column_Heading_Areas
  121. 4 Sizing Row and Column Headings=Sizing_Row_and_Column_Headings
  122. 4 Setting Row and Column Text=Setting_Row_and_Column_Text
  123. 2 File Handing
  124. 3 Reading and Writing Files=Reading_and_Writing_Files
  125. 3 Using BLOB access=Using_BLOB_access
  126. 2 Worksheet Functions
  127. 3 ABS=ABS
  128. 3 ACOS=ACOS
  129. 3 ACOSH=ACOSH
  130. 3 ADDRESS=ADDRESS
  131. 3 AND=AND
  132. 3 ASIN=ASIN
  133. 3 ASINH=ASINH
  134. 3 ATAN=ATAN
  135. 3 ATAN2=ATAN2
  136. 3 ATANH=ATANH
  137. 3 AVERAGE=AVERAGE
  138. 3 CEILING=CEILING
  139. 3 CHAR=CHAR
  140. 3 CHOOSE=CHOOSE
  141. 3 CLEAN=CLEAN
  142. 3 CODE=CODE
  143. 3 COLUMN=COLUMN
  144. 3 COLUMNS=COLUMNS
  145. 3 CONCATENATE=CONCATENATE
  146. 3 COS=COS
  147. 3 COSH=COSH
  148. 3 COUNT=COUNT
  149. 3 COUNTIF=COUNTIF
  150. 3 COUNTA=COUNTA
  151. 3 DATE=DATE
  152. 3 DATEVALUE=DATEVALUE
  153. 3 DAY=DAY
  154. 3 DB=DB
  155. 3 DDB=DDB
  156. 3 DOLLAR=DOLLAR
  157. 3 ERROR.TYPE=ERROR_TYPE
  158. 3 EVEN=EVEN
  159. 3 EXACT=EXACT
  160. 3 EXP=EXP
  161. 3 FACT=FACT
  162. 3 FALSE=FALSE
  163. 3 FIND=FIND
  164. 3 FIXED=FIXED
  165. 3 FLOOR=FLOOR
  166. 3 FV=FV
  167. 3 HLOOKUP=HLOOKUP
  168. 3 HOUR=HOUR
  169. 3 IF=IF
  170. 3 INDEX=INDEX
  171. 3 INDIRECT=INDIRECT
  172. 3 INT=INT
  173. 3 IPMT=IPMT
  174. 3 IRR=IRR
  175. 3 ISBLANK=ISBLANK
  176. 3 ISERR=ISERR
  177. 3 ISERROR=ISERROR
  178. 3 ISLOGICAL=ISLOGICAL
  179. 3 ISNA=ISNA
  180. 3 ISNONTEXT=ISNONTEXT
  181. 3 ISNUMBER=ISNUMBER
  182. 3 ISREF=ISREF
  183. 3 ISTEXT=ISTEXT
  184. 3 LEFT=LEFT
  185. 3 LEN=LEN
  186. 3 LN=LN
  187. 3 LOG=LOG
  188. 3 LOG10=LOG10
  189. 3 LOOKUP=LOOKUP
  190. 3 LOWER=LOWER
  191. 3 MATCH=MATCH
  192. 3 MAX=MAX
  193. 3 MID=MID
  194. 3 MIN=MIN
  195. 3 MINUTE=MINUTE
  196. 3 MIRR=MIRR
  197. 3 MOD=MOD
  198. 3 MONTH=MONTH
  199. 3 N=N
  200. 3 NOT=NOT
  201. 3 NOW=NOW
  202. 3 NPER=NPER
  203. 3 NPV=NPV
  204. 3 ODD=ODD
  205. 3 OFFSET=OFFSET
  206. 3 OR=OR
  207. 3 PI=PI
  208. 3 PMT=PMT
  209. 3 PPMT=PPMT
  210. 3 PRODUCT=PRODUCT
  211. 3 PROPER=PROPER
  212. 3 PV=PV
  213. 3 RAND=RAND
  214. 3 RATE=RATE
  215. 3 REPLACE=REPLACE
  216. 3 REPT=REPT
  217. 3 RIGHT=RIGHT
  218. 3 ROUND=ROUND
  219. 3 ROUNDDOWN=ROUNDDOWN
  220. 3 ROUNDUP=ROUNDUP
  221. 3 ROW=ROW
  222. 3 ROWS=ROWS
  223. 3 SEARCH=SEARCH
  224. 3 SECOND=SECOND
  225. 3 YEAR SIGN=YEAR_SIGN
  226. 3 SIN=SIN
  227. 3 SINH=SINH
  228. 3 SLN=SLN
  229. 3 SQRT=SQRT
  230. 3 STDEV=STDEV
  231. 3 STDEVP=STDEVP
  232. 3 SUBSTITUTE=SUBSTITUTE
  233. 3 SUM=SUM
  234. 3 SUMIF=SUMIF
  235. 3 SUMSQ=SUMSQ
  236. 3 SYD=SYD
  237. 3 T=T
  238. 3 TAN=TAN
  239. 3 TANH=TANH
  240. 3 TEXT=TEXT
  241. 3 TIME=TIME
  242. 3 TIMEVALUE=TIMEVALUE
  243. 3 TODAY=TODAY
  244. 3 TRIM=TRIM
  245. 3 TRUE=TRUE
  246. 3 TRUNC=TRUNC
  247. 3 TYPE=TYPE
  248. 3 UPPER=UPPER
  249. 3 VALUE=VALUE
  250. 3 VAR=VAR
  251. 3 VARP=VARP
  252. 3 VDB=VDB
  253. 3 VLOOKUP=VLOOKUP
  254. 3 WEEKDAY=WEEKDAY
  255. 3 YEAR=YEAR
  256. 1 Working with Objects
  257. 2 Working with Objects=Working_with_Objects
  258. 2 Creating Objects
  259. 3 Creating Objects=Creating_Objects
  260. 3 Creating Objects with Methods=Creating_Objects_with_Methods
  261. 3 Interactively Drawing Objects=Interactively_Drawing_Objects
  262. 3 Picture Objects=Picture_Objects
  263. 3 Setting Mouse Mode=Setting_Mouse_Mode
  264. 3 Identifying Objects=Identifying_Objects
  265. 3 Naming Objects=Naming_Objects
  266. 2 Selecting Objects
  267. 3 Selecting Objects=Selecting_Objects
  268. 3 Interactively Selecting Objects=Interactively_Selecting_Objects
  269. 3 Limiting Interactive Object Selection=Limiting_Interactive_Object_Selection
  270. 3 Selecting Objects Programmatically=Selecting_Objects_Programmatically
  271. 2 Positioning Objects
  272. 3 Moving, Sizing, and Arranging Objects=Moving_Sizing_and_Arranging_Objects
  273. 3 Interactively Positioning Objects=Interactively_Positioning_Objects
  274. 3 Positioning Objects Programmatically=Positioning_Objects_Programmatically
  275. 3 Determining Object Position and Size=Determining_Object_Position_and_Size
  276. 3 Arranging Overlapping Objects=Arranging_Overlapping_Objects
  277. 3 Arranging Objects and Object Order=Arranging_Objects_and_Object_Order
  278. 2 Formatting Objects
  279. 3 Formatting Objects=Formatting_Objects
  280. 3 Formatting Colors and Patterns=Formatting_Colors_and_Patterns
  281. 3 Showing and Hiding Objects=Showing_and_Hiding_Objects
  282. 3 Formatting List Boxes=Formatting_List_Boxes
  283. 3 Formatting Check Boxes=Formatting_Check_Boxes
  284. 3 Formatting Buttons=Formatting_Buttons
  285. 3 Selecting Check Box and List Box Items=Selecting_Check_Box_and_List_Box_Items
  286. 3 Setting Values Interactively=Setting_Values_Interactively
  287. 3 Setting Values Programmatically=Setting_Values_Programmatically
  288. 3 Setting Values by Cell Reference=Setting_Values_by_Cell_Reference
  289. 3 Editing Polygons=Editing_Polygons
  290. 1 Charting Formula One Data
  291. 2 Working with Chart Objects=Working_with_Chart_Objects
  292. 2 Using the Chart Wizard=Using_the_Chart_Wizard
  293. 2 Chart Formatting=Additional_Chart_Formatting
  294. 2 Chart Options=Chart_Options
  295. 2 Referencing Data on Another Worksheet=Referencing_Data_on_Another_Worksheet
  296. 1 Connecting to a Database
  297. 2 Working with Databases=Working_with_Databases
  298. 2 Installing the ODBC Drivers=Installing_the_ODBC_Drivers
  299. 2 Setting up a Data Source=Setting_up_a_Data_Source
  300. 2 Overview of Formula One Connections=Overview_of_Formula_One_Connections
  301. 2 Connecting to the Data Source=Connecting_to_the_Data_Source
  302. 2 Querying the Data Source=Querying_the_Data_Source
  303. 2 Disconnecting from the Data Source=Disconnecting_from_the_Data_Source
  304. 1 Printing Worksheets
  305. 2 Printing Worksheets=Printing_Worksheets
  306. 2 Specifying Print Areas=Specifying_Print_Areas
  307. 2 Specifying Row and Column Print Titles=Specifying_Row_and_Column_Print_Titles
  308. 2 Specifying Headers and Footers=Specifying_Headers_and_Footers
  309. 2 Specifying Page Breaks=Specifying_Page_Breaks
  310. 2 Page Break Methods=Page_Break_Methods
  311. 2 Setting Printing Orientation=Setting_Printing_Orientation
  312. 2 Using the Windows API DEVMODE Structure=Using_the_Windows_API_DEVMODE_Structure
  313. 1 Formula One Workbook Properties
  314. 2 Formula One Workbook Properties=General_Tab
  315. 1 Programming Reference
  316. 2 The Formula One Control=The_Formula_One_Control
  317. 2 Using Properties=Using_Properties
  318. 2 Setting Properties=Setting_Properties
  319. 2 Property Data Types=Property_Data_Types
  320. 2 Retrieving Property Values=Returning_Property_Values
  321. 2 Properties that take an index=Properties_that_take_an_index
  322. 2 Using Methods=Using_Methods
  323. 2 Handling Errors=Handling_Errors
  324. 2 OCX Property and Method Reference
  325. 3 Dialog box Methods
  326. 4 CalculationDlg=CalculationDlg_Method
  327. 4 ColorPaletteDlg=ColorPaletteDlg_Method
  328. 4 ColWidthDlg=ColWidthDlg_Method
  329. 4 DefinedNameDlg=DefinedNameDlg_Method
  330. 4 FilePageSetupDlg=FilePageSetupDlg_Method
  331. 4 FilePrintSetupDlg=FilePrintSetupDlg_Method
  332. 4 FormatAlignmentDlg=FormatAlignmentDlg_Method
  333. 4 FormatBorderDlg=FormatBorderDlg_Method
  334. 4 FormatDefaultFontDlg=FormatDefaultFontDlg_Method
  335. 4 FormatFontDlg=FormatFontDlg_Method
  336. 4 FormatNumberDlg=FormatNumberDlg_Method
  337. 4 FormatPatternDlg=FormatPatternDlg_Method
  338. 4 GotoDlg=GotoDlg_Method
  339. 4 LineStyleDlg=LineStyleDlg_Method
  340. 4 ObjNameDlg=ObjNameDlg_Method
  341. 4 ObjOptionsDlg=ObjOptionsDlg_Method
  342. 4 OpenFileDlg=OpenFileDlg_Method
  343. 4 ProtectionDlg=ProtectionDlg_Method
  344. 4 RowHeightDlg=RowHeightDlg_Method
  345. 4 SaveFileDlg=SaveFileDlg_Method
  346. 4 SortDlg=SortDlg_Method
  347. 4 ValidationRuleDlg=ValidationRuleDlg_Method
  348. 3 Workbook Methods and Properties
  349. 4 Attach=Attach_Method
  350. 4 AttachToSS=AttachToSS_Method
  351. 4 InitTable=InitTable_Method
  352. 4 SSUpdate=SSUpdate_Method
  353. 4 SS=SS_Method
  354. 4 SwapTables=SwapTables_Method
  355. 4 TableName=TableName_Property
  356. 4 Title=Title_Property
  357. 3 Worksheet Methods and Properties
  358. 4 DeleteSheets=DeleteSheets_Method
  359. 4 EditDeleteSheets Method=EditDeleteSheets_Method
  360. 4 EditInsertSheets=EditInsertSheets_Method
  361. 4 InsertSheets=InsertSheets_Method
  362. 4 NumSheets=NumSheets_Property
  363. 4 Sheet=Sheet_Property
  364. 4 SheetName=SheetName_Property
  365. 4 SheetSelected=SheetSelected_Property
  366. 3 Data Entry Methods and Properties
  367. 4 AllowAutoFill Property=AllowAutoFill_Property
  368. 4 AllowEditHeaders=AllowEditHeaders_Property
  369. 4 AllowInCellEditing=AllowInCellEditing_Property
  370. 4 AutoFillItems=AutoFillItems_Property
  371. 4 AutoFillItemsCount=AutoFillItemsCount_Property
  372. 4 CancelEdit=CancelEdit_Method
  373. 4 Clip=Clip_Property
  374. 4 ClipValues=ClipValues_Property
  375. 4 DeleteAutoFillItems=DeleteAutoFillItems_Method
  376. 4 EndEdit=EndEdit_Method
  377. 4 Entry=Entry_Property
  378. 4 EntryRC=EntryRC_Property
  379. 4 FormattedText=FormattedText_Property
  380. 4 FormattedTextRC=FormattedTextRC_Property
  381. 4 Formula=Formula_Property
  382. 4 FormulaRC=FormulaRC_Property
  383. 4 GetTabbedText=GetTabbedText_Method
  384. 4 GetValidationRule=GetValidationRule_Method
  385. 4 Logical=Logical_Property
  386. 4 LogicalRC=LogicalRC_Property
  387. 4 Number=Number_Property
  388. 4 NumberRC=NumberRC_Property
  389. 4 SetTabbedText=SetTabbedText_Method
  390. 4 SetValidationRule=SetValidationRule_Method
  391. 4 StartEdit=StartEdit_Method
  392. 4 Text=Text_Property
  393. 4 TextRC=TextRC_Property
  394. 4 Type=Type_Property
  395. 4 TypeRC=TypeRC_Property
  396. 3 Database Methods
  397. 4 ODBCConnect Method=ODBCConnect_Method
  398. 4 ODBCDisconnect Method=ODBCDisconnect_Method
  399. 4 ODBCQuery Method=ODBCQuery_Method
  400. 3 Formatting Methods and Properties
  401. 4 AllowDesigner=AllowDesigner_Property
  402. 4 AllowResize=AllowResize_Property
  403. 4 BackColor=BackColor_Property
  404. 4 BorderStyle=BorderStyle_Property
  405. 4 ColHidden=ColHidden_Property
  406. 4 ColText=ColText_Property
  407. 4 ColWidth=ColWidth_Property
  408. 4 ColWidthTwips=ColWidthTwips_Property
  409. 4 ColWidthUnits=ColWidthUnits_Property
  410. 4 ExtraColor=ExtraColor_Property
  411. 4 FixedCol=FixedCol_Property
  412. 4 FixedCols=FixedCols_Property
  413. 4 FixedRow=FixedRow_Property
  414. 4 FixedRows=FixedRows_Property
  415. 4 FormatCurrency0=FormatCurrency0_Method
  416. 4 FormatCurrency2=FormatCurrency2_Method
  417. 4 FormatFixed=FormatFixed_Method
  418. 4 FormatFixed2=FormatFixed2_Method
  419. 4 FormatFraction=FormatFraction_Method
  420. 4 FormatGeneral=FormatGeneral_Method
  421. 4 FormatHmmampm=FormatHmmampm_Method
  422. 4 FormatMdyy=FormatMdyy_Method
  423. 4 FormatPercent=FormatPercent_Method
  424. 4 FormatScientific=FormatScientific_Method
  425. 4 GetAlignment=GetAlignment_Method
  426. 4 GetBorder=GetBorder_Method
  427. 4 GetDefaultFont=GetDefaultFont_Method
  428. 4 GetFont=GetFont_Method
  429. 4 GetPattern=GetPattern_Method
  430. 4 HdrHeight=HdrHeight_Property
  431. 4 HdrWidth=HdrWidth_Property
  432. 4 LaunchDesigner=LaunchDesigner_Method
  433. 4 LeftCol=LeftCol_Property
  434. 4 MaxCol=MaxCol_Property
  435. 4 MaxRow=MaxRow_Property
  436. 4 MinCol=MinCol_Property
  437. 4 MinRow=MinRow_Property
  438. 4 NumberFormat=NumberFormat_Property
  439. 4 PaletteEntry=PaletteEntry_Property
  440. 4 RowHeight=RowHeight_Property
  441. 4 RowHidden=RowHidden_Property
  442. 4 RowText=RowText_Property
  443. 4 ScrollToLastRC=ScrollToLastRC_Property
  444. 4 SetAlignment=SetAlignment_Method
  445. 4 SetBorder=SetBorder_Method
  446. 4 SetColHidden=SetColHidden_Method
  447. 4 SetColWidth=SetColWidth_Method
  448. 4 SetColWidthAuto=SetColWidthAuto_Method
  449. 4 SetColWidthTwips=SetColWidthTwips_Method
  450. 4 SetDefaultFont=SetDefaultFont_Method
  451. 4 SetFont=SetFont_Method
  452. 4 SetPattern=SetPattern_Method
  453. 4 SetRowHeight=SetRowHeight_Method
  454. 4 SetRowHeightAuto=SetRowHeightAuto_Method
  455. 4 SetRowHidden=SetRowHidden_Method
  456. 4 ShowColHeading=ShowColHeading_Property
  457. 4 ShowEditBar=ShowEditBar_Property
  458. 4 ShowEditBarCellRef=ShowEditBarCellRef_Property
  459. 4 ShowFormulas=ShowFormulas_Property
  460. 4 ShowGridLines=ShowGridLines_Property
  461. 4 ShowHScrollBar=ShowHScrollBar_Property
  462. 4 ShowRowHeading=ShowRowHeading_Property
  463. 4 ShowSelections=ShowSelections_Property
  464. 4 ShowTabs Property=ShowTabs_Property
  465. 4 ShowTypeMarkers=ShowTypeMarkers_Property
  466. 4 ShowVScrollBar=ShowVScrollBar_Property
  467. 4 ShowZeroValues=ShowZeroValues_Property
  468. 4 TopLeftText=TopLeftText_Property
  469. 4 TopRow=TopRow_Property
  470. 3 Worksheet Editing Methods and Properties
  471. 4 AllowArrows=AllowArrows_Property
  472. 4 AllowDelete=AllowDelete_Property
  473. 4 AllowFillRange=AllowFillRange_Property
  474. 4 AllowMoveRange=AllowMoveRange_Property
  475. 4 AllowTabs=AllowTabs_Property
  476. 4 ClearRange=ClearRange_Method
  477. 4 CopyAll=CopyAll_Method
  478. 4 CopyRange=CopyRange_Method
  479. 4 CopyRangeEx=CopyRangeEx_Method
  480. 4 DeleteRange=DeleteRange_Method
  481. 4 EditClear=EditClear_Method
  482. 4 EditCopy=EditCopy_Method
  483. 4 EditCopyDown=EditCopyDown_Method
  484. 4 EditCopyRight=EditCopyRight_Method
  485. 4 EditCut=EditCut_Method
  486. 4 EditDelete=EditDelete_Method
  487. 4 EditInsert=EditInsert_Method
  488. 4 EditPaste=EditPaste_Method
  489. 4 EditPasteValues=EditPasteValues_Method
  490. 4 EnterMovesDown=EnterMovesDown_Property
  491. 4 InsertRange=InsertRange_Method
  492. 4 MoveRange=MoveRange_Method
  493. 3 Recalculation Methods and Properties
  494. 4 AllowFormulas=AllowFormulas_Property
  495. 4 AutoRecalc=AutoRecalc_Property
  496. 4 CalculationDlg=CalculationDlg_Method
  497. 4 CheckRecalc=CheckRecalc_Method
  498. 4 GetIteration=GetIteration_Method
  499. 4 Recalc=Recalc_Method
  500. 4 SetIteration=SetIteration_Method
  501. 3 Selection Methods and Properties
  502. 4 AddSelection=AddSelection_Method
  503. 4 AllowSelections=AllowSelections_Property
  504. 4 Col=Col_Property
  505. 4 DefinedName=DefinedName_Property
  506. 4 DefinedNameByIndex=DefinedNameByIndex_Property
  507. 4 DefinedNameCount=DefinedNameCount_Method
  508. 4 DeleteDefinedName=DeleteDefinedName_Method
  509. 4 FormatRCNr=FormatRCNr_Method
  510. 4 GetActiveCell=GetActiveCell_Method
  511. 4 GetHdrSelection=GetHdrSelection_Method
  512. 4 GetSelection=GetSelection_Method
  513. 4 Row=Row_Property
  514. 4 RowMode=RowMode_Property
  515. 4 Selection=Selection_Property
  516. 4 SelectionCount=SelectionCount_Property
  517. 4 SelEndCol=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties
  518. 4 SelEndRow=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties
  519. 4 SelStartCol=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties
  520. 4 SelStartRow=SelEndCol_SelEndRow_SelStartCol_and_SelStartRow_Properties
  521. 4 SetActiveCell=SetActiveCell_Method
  522. 4 SetHdrSelection=SetHdrSelection_Method
  523. 4 SetSelection=SetSelection_Method
  524. 4 ShowActiveCell=ShowActiveCell_Method
  525. 4 ShowSelections=ShowSelections_Property
  526. 3 Object Methods and Properties
  527. 4 AllowObjSelections=AllowObjSelections_Property
  528. 4 GetLineStyle=GetLineStyle_Method
  529. 4 LineStyleDlg=LineStyleDlg_Method
  530. 4 ObjAddItem=ObjAddItem_Method
  531. 4 ObjAddSelection=ObjAddSelection_Method
  532. 4 ObjBringToFront=ObjBringToFront_Method
  533. 4 ObjDeleteItem=ObjDeleteItem_Method
  534. 4 ObjFirstID=ObjFirstID_Method
  535. 4 ObjGetCell=ObjGetCell_Method
  536. 4 ObjGetItemCount=ObjGetItemCount_Method
  537. 4 ObjGetPos=ObjGetPos_Method
  538. 4 ObjGetSelection=ObjGetSelection_Method
  539. 4 ObjGetSelectionCount=ObjGetSelectionCount_Method
  540. 4 ObjGetType=ObjGetType_Method
  541. 4 ObjInsertItem=ObjInsertItem_Method
  542. 4 ObjItem=ObjItem_Property
  543. 4 ObjItems=ObjItems_Property
  544. 4 ObjName=ObjName_Property
  545. 4 ObjNameDlg=ObjNameDlg_Method
  546. 4 ObjNameToID=ObjNameToID_Method
  547. 4 ObjNew=ObjNew_Method
  548. 4 ObjNewPicture=ObjNewPicture_Method
  549. 4 ObjNextID=ObjNextID_Method
  550. 4 ObjOptionsDlg=ObjOptionsDlg_Method
  551. 4 ObjPosToTwips=ObjPosToTwips_Method
  552. 4 ObjSendToBack=ObjSendToBack_Method
  553. 4 ObjSetCell=ObjSetCell_Method
  554. 4 ObjSetPicture=ObjSetPicture_Method
  555. 4 ObjSetPos=ObjSetPos_Method
  556. 4 ObjSetSelection=ObjSetSelection_Method
  557. 4 ObjText=ObjText_Property
  558. 4 ObjValue=ObjValue_Property
  559. 4 ObjVisible=ObjVisible_Property
  560. 4 PolyEditMode=PolyEditMode_Property
  561. 4 SetLineStyle=SetLineStyle_Method
  562. 3 Printing Properties and Methods
  563. 4 AddColPageBreak=AddColPageBreak_Method
  564. 4 AddPageBreak=AddPageBreak_Method
  565. 4 AddRowPageBreak=AddRowPageBreak_Method
  566. 4 FilePrint=FilePrint_Method
  567. 4 GetPrintScale=GetPrintScale_Method
  568. 4 NextColPageBreak=NextColPageBreak_Method
  569. 4 NextRowPageBreak=NextRowPageBreak_Method
  570. 4 PrintArea=PrintArea_Property
  571. 4 PrintBottomMargin=PrintBottomMargin_Property
  572. 4 PrintColHeading=PrintColHeading_Property
  573. 4 PrintDevMode=PrintDevMode_Property
  574. 4 PrintFooter=PrintFooter_Property
  575. 4 PrintGridLines=PrintGridLines_Property
  576. 4 PrintHCenter=PrintHCenter_Property
  577. 4 PrintHeader=PrintHeader_Property
  578. 4 PrintLandscape=PrintLandscape_Property
  579. 4 PrintLeftMargin=PrintLeftMargin_Property
  580. 4 PrintLeftToRight=PrintLeftToRight_Property
  581. 4 PrintNoColor=PrintNoColor_Property
  582. 4 PrintRightMargin=PrintRightMargin_Property
  583. 4 PrintRowHeading=PrintRowHeading_Property
  584. 4 PrintTitles=PrintTitles_Property
  585. 4 PrintTopMargin=PrintTopMargin_Property
  586. 4 PrintVCenter=PrintVCenter_Property
  587. 4 RemoveColPageBreak=RemoveColPageBreak_Method
  588. 4 RemovePageBreak=RemovePageBreak_Method
  589. 4 RemoveRowPageBreak=RemoveRowPageBreak_Method
  590. 4 SetPrintAreaFromSelection Method=SetPrintAreaFromSelection_Method
  591. 4 SetPrintScale=SetPrintScale_Method
  592. 4 SetPrintTitlesFromSelection Method=SetPrintTitlesFromSelection_Method
  593. 3 Event-related Methods and Properties
  594. 4 DoCancelEdit=DoCancelEdit_Property
  595. 4 DoClick=DoClick_Property
  596. 4 DoDblClick=DoDblClick_Property
  597. 4 DoEndEdit=DoEndEdit_Property
  598. 4 DoEndRecalc=DoEndRecalc_Property
  599. 4 DoObjClick=DoObjClick_Property
  600. 4 DoObjDblClick=DoObjDblClick_Property
  601. 4 DoObjGotFocus=DoObjGotFocus_Property
  602. 4 DoObjLostFocus=DoObjLostFocus_Property
  603. 4 DoObjValueChanged=DoObjValueChanged_Property
  604. 4 DoRClick=DoRClick_Property
  605. 4 DoRDblClick=DoRDblClick_Property
  606. 4 DoSelChange=DoSelChange_Property
  607. 4 DoStartEdit=DoStartEdit_Property
  608. 4 DoStartRecalc=DoStartRecalc_Property
  609. 4 DoTopLeftChanged=DoTopLeftChanged_Property
  610. 3 Miscellaneous Methods and Properties
  611. 4 AboutBox=AboutBox_Method
  612. 4 AppName=AppName_Property
  613. 4 ClearClipboard=ClearClipboard_Method
  614. 4 DragIcon=DragIcon_Property
  615. 4 DragMode=DragMode_Property
  616. 4 Draw=Draw_Method
  617. 4 Enabled=Enabled_Property
  618. 4 EnableProtection=EnableProtection_Property
  619. 4 ErrorNumberToText=ErrorNumberToText_Method
  620. 4 FileName=FileName_Property
  621. 4 GetProtection=GetProtection_Method
  622. 4 HeapMin=HeapMin_Method
  623. 4 hWnd=HWnd_Method
  624. 4 LastCol=LastCol_Property
  625. 4 LastColForRow=LastColForRow_Property
  626. 4 LastRow=LastRow_Property
  627. 4 LeftCol=LeftCol_Property
  628. 4 Mode=Mode_Property
  629. 4 Modified=Modified_Property
  630. 4 MouseIcon=MouseIcon_Property
  631. 4 MousePointer=MousePointer_Property
  632. 4 RangeToTwips=RangeToTwips_Method
  633. 4 Read=Read_Method
  634. 4 ReadBromBlob=ReadFromBlob_Method
  635. 4 Repaint=Repaint_Property
  636. 4 SaveWindowInfo=SaveWindowInfo_Method
  637. 4 SetProtection=SetProtection_Method
  638. 4 Sort=Sort_Method
  639. 4 Sort3=Sort3_Method
  640. 4 SSVersion=SSVersion_Method
  641. 4 TopRow=TopRow_Property
  642. 4 TransactCommit=TransactCommit_Method
  643. 4 TransactRollback=TransactRollback_Method
  644. 4 TransactStart=TransactStart_Method
  645. 4 TwipsToRC=TwipsToRC_Method
  646. 4 ViewScale=ViewScale_Property
  647. 4 Visible=Visible_Property
  648. 4 Write=Write_Method
  649. 4 WriteToBlob=WriteToBlob_Method
  650. 2 Events
  651. 3 Using Events=Using_Events
  652. 3 Drilling for Data=Drilling_for_Data
  653. 3 Events and Other Controls=Events_and_Other_Controls
  654. 3 Capturing Mouse Movements=Capturing_Mouse_Movements
  655. 3 Click Event=Click_Event
  656. 3 DblClick Event=DblClick_Event
  657. 3 DragDrop Event=DragDrop_Event
  658. 3 DragOver Event=DragOver_Event
  659. 3 EndEdit Event=EndEdit_Event
  660. 3 EndRecalc Event=EndRecalc_Event
  661. 3 GotFocus Event=GotFocus_Event
  662. 3 KeyDown, KeyUp Events=KeyDown_KeyUp_Events
  663. 3 KeyPress Event=KeyPress_Event
  664. 3 LostFocusEvent=LostFocusEvent
  665. 3 Modified Event=Modified_Event
  666. 3 MouseDown, MouseUp Events=MouseDown_MouseUp_Events
  667. 3 MouseMove Event=MouseMove_Event
  668. 3 ObjClick Event=ObjClick_Event
  669. 3 ObjDblClick Event=ObjDblClick_Event
  670. 3 ObjGotFocus Event=ObjGotFocus_Event
  671. 3 ObjLostFocus Event=ObjLostFocus_Event
  672. 3 ObjValueChanged Event=ObjValueChanged_Event
  673. 3 RClick Event=RClick_Event
  674. 3 RDblClick Event=RDblClick_Event
  675. 3 SelChange Event=SelChange_Event
  676. 3 StartEdit Event=StartEdit_Event
  677. 3 StartRecalc Event=StartRecalc_Event
  678. 3 TopLeftChanged Event=TopLeftChanged_Event
  679. 3 ValidationFailed Event=ValidationFailed_Event
  680. 1 Performance Tuning and Specification
  681. 2 Performance Tuning=Performance_Tuning
  682. 2 Specifications=Specifications
  683.